SELECT Id FROM new_searchtable
where
(town = 'Cornish' and state='NH'
or town = 'Eastman' and state='NH'
or town = 'Enfield' and state='NH'
or town = 'Hanover' and state='NH'
or town = 'Lebanon' and state='NH'
or town = 'Lyme' and state='NH'
or town = 'Plainfield' and state='NH'
)
and (type = 'R' or type ='O')
and (bedrooms >='4') and (bedrooms >='4')
AND list_price BETWEEN '0' AND '30000000'
ORDER BY list_price Desc
Upper Valley Area NH Homes page 10
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:Discover a rare gem in the heart of Lebanon—this expansive single level 4-bedroom, 4-bathroom home is nestled on 43 picturesque acres. Enjoy stunning westerly views, ample living space, and the perfect blend of privacy and convenience. This unique property offers the tranquility of country living with all the benefits of being close to town. With several acres of open pasture land and a barn/stable, the property would be well suited for horses or other grazing animals. The 10 KW solar array reduces current power demands with room for future expansion. Imagine snowshoeing, and cross-country skiing on your own land in the winter while enjoying the pollinator flowers and organic vegetable gardens by the half basketball court. The downstairs includes a library, bar, and a large space to create what you want. In addition, the property benefits from easy access to downtown Lebanon, Dartmouth College, Dartmouth-Hitchcock, I89 and I91, Lebanon Airport, and the Dartmouth Coach, which goes to New York or Boston. Don’t miss out on this exceptional opportunity located at the end of a dead-end road! Home is being sold as is. The property does need work to make it special again.
Description:Possibly one of the most spectacular locations on Mascoma Lake you'll ever find. The "Lovett Cottage" has not been offered for sale since 1971 and boast direct Southwesterly exposure with 125 feet of private lake frontage. The original cottage built circa 1940 then remodeled and expanded in 2005 with a second floor addition which included a new kitchen, dining room, living room and bedroom/balcony. The house along with an extensive deck and dock system is grandfathered into is current location making it extremely unique and a rare find that will most certainly never be found again. The deck and dock system feel almost like they are vaulted out over the lake. The privacy here is amazing, imagine sitting by the shore on some quiet summer evening, with your feet in the water, sipping on a cool drink, listening to the waves gently slapping the rocky shore line. Nothing else to do but watch the sun slowly setting behind Shaker Mountain while your children or grandchildren are at play. The crackle of the firepit as tales from the past are being spun, and then your the grandchild runs over and whacks you in the face with a sun fish. Look what we caught Grampa! This is not a house, it's a lifetime of memories that we are selling, make them yours, call for a private showing today, you'll be glad you did.
Description:Bring you chickens, your green thumb and your swim suit and enjoy everything this 3.2+/- acre property has to offer approx. 15 minutes from Dartmouth College and Dartmouth Health! This 3-4 bedroom, 2.5 bedroom home features charming exposed beams, open eat-in kitchen/dining room with a wood fireplace, cozy living room with reading nook and a wood stove for those chilly winter nights, a patio leading to a screened porch, garden space, multiple outbuildings and a swimming and skating pond! This home has something for everyone including a trail network within walking distance and Trescott trail access off of Dogford Rd. for mountain biking about 3 miles away. Do you love to ski? The Dartmouth Skiway is approx. 15 minutes as well! What a spot! Delayed showings start at the Open House on Saturday, Feb 15 from 11:00-1:00. Note - Town has it listed as a 3 bedroom so we assume it's a 3 bedroom septic.
Description:This 4 bedroom, 3.5 bath contemporary is beautifully situated on a corner 1.97+/- acre lot in the village of Etna in Hanover. The main floor features an open cherry kitchen with granite counters, lots of storage and light filled dining area that leads to a brand new deck. The living room with it's cozy woodstove and soaring catherdral ceilings is perfect for gathering and entertaining and the primary suite with a walk through closet and a full bath is nicely nestled on the backside of the home. Upstairs features 3 bedrooms, a full bath and a loft space overlooking the living room. In the walkout basement you have a mudroom off the 2 car garage, big family room, 3/4 bath, laundry and a bonus room for exercise equipment and all your outdoor gear. Love to bike and hike?! Numerous trails within super close proximity - Trescott trails, AT and more! A great house in a great location! Delayed showings start on Saturday, March 29th at the Open House from 11:00-1:00.
Description:**Open House Saturday 4/12 and Sunday 4/13 from 11:00 - 3:00!** Just 15 minutes from DHMC, Dartmouth College, AND 12A, this thoughtfully updated ranch offers the peace and quiet of a rural setting within a wonderful neighborhood. A large kitchen (with Crown Point cabinetry, marble countertops, and newer appliances), spacious living areas, three bedrooms, and updated 3/4 primary and full hall baths complete the main floor. Downstairs you'll find another bedroom, family room, and office (all with new carpet), a full bath, laundry/workshop, and storage galore. New paint, garage door system, wood shed, Trex deck, fenced yard, mature flower gardens, and raised vegetable gardens enhance the exterior. Energy efficiency is a priority: windows installed since 2017 are Anderson 400 Low-E, a fully-owned 10-megawatt solar panel system, an electric heat pump hot water heater for domestic hot water, and a Level-2 CCS EV charger. Too many updates to name here - a full list available upon request.